package com.sora.sora.manager.mapper;

import com.sora.sora.common.model.entity.UserEntity;
import org.apache.ibatis.annotations.Mapper;

import java.util.Date;
import java.util.List;

@Mapper
public interface SysUserMapper {

    int count();

    int queryStatus(int uid);

    int banUser(int uid);

    int ban(int uid, String reason, Date time, int expire);

    int startUser(int uid);

    int resetPassword(int uid, String password);

    int resetAvatar(int uid, String avatar);

    UserEntity queryUserByEmail(String email);

    UserEntity queryUserById(int id);

    String queryEmailById(int uid);

    List<UserEntity> queryUserByName(String name);

    List<UserEntity> query();

}
